﻿CREATE TABLE [dbo].[CHIENDICH] (
    [IdDoiTuong]      UNIQUEIDENTIFIER NOT NULL,
    [MaHieu]          NCHAR (100)      NOT NULL,
    [TenChienDich]    NCHAR (100)      NOT NULL,
    [LoaiChienDich]   NCHAR (100)      NULL,
    [NgayBatDau]      DATETIME         NOT NULL,
    [NgayKetThuc]     DATETIME         NULL,
    [TinhTrang]       NCHAR (100)      NULL,
    [DienGiai]        NVARCHAR (MAX)   NULL,
    [SLDaGui]         INT              NULL,
    [SLHoiAmKyVong]   FLOAT            NULL,
    [TongSoHoiAm]     INT              NULL,
    [TongSoTiemNang]  INT              NULL,
    [TongSoLienHe]    INT              NULL,
    [DoanhThuKyVong]  FLOAT            NULL,
    [ChiPhiThuc]      FLOAT            NULL,
    [ChiPhiDuTru]     FLOAT            NULL,
    [TongSoCoHoi]     INT              NULL,
    [TongGiaTri]      FLOAT            NULL,
    [SoCoHoiThang]    INT              NULL,
    [TongGiaTriThang] FLOAT            NULL
);

